package org.example.etl.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.example.etl.entity.AtcDuty;

public interface ATCDutyMapper extends BaseMapper<AtcDuty> {

    @Select(" SELECT COUNT(*) from atcduty_number where atc_duty_person=#{atcDutyPerson};")
    public boolean isExistThisAtcDuty(String atcDutyPerson);

    @Update("update atcduty_number set count=count+'1' where atc_duty_person=#{atcDutyPerson}; ")
    public void updateAnAtcDutyMsg(String atcDutyPerson);

}
